<?xml version = '1.0' encoding = 'UTF-8'?>
<HBRRepo><variables/><rulesets/><rules/><components><component type="script" id="1" name="Plan_Only_Trends" product="Planning"><property name="application">BYOCOA</property><property name="plantype">OEP_FS</property><property name="display_label">Plan_Only_Trends</property><property name="seeded">true</property><script type="calcscript">elseif("OFS_Trend"->"BegBalance"==6)
			if(@isuda("Account","CalcRound"))
				"OFS_Calculated" = @Round(@avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @avgrange(skipnone,"OEP_Forecast"->"OFS_Total Plan"->@member(@prevsibling(@currmbr(Years))),@relative("YearTotal",0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
	endif                
	                
elseif("OFS_Trend"->"BegBalance"==8)
			if(@isuda("Account","CalcRound"))
				"OFS_Calculated" = @Round(@prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
			else
				"OFS_Calculated" = @prior("OEP_Forecast"->"OFS_Total Plan",1, @LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
			endif
elseif("OFS_Trend"->"BegBalance"==10)
				if(@isuda("Account","calcRound"))
					"OFS_Calculated" = @Round(@prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance"));
				else
					"OFS_Calculated" = @prior("OFS_Total Plan",1,@LEVMBRS ("Years", 0))*(1+"OFS_% Increase/(Decrease)"->"BegBalance");
	endif</script></component></components></HBRRepo>